Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

Fruit Ninja
Software; Phone apps

A mobile game where players slice fruits as they are thrown ...

Compare Bookings
Software; Phone apps

Not only does Compare Bookings let you search for hotel ...

Dragon Dictation
Software; Phone apps

A speech recognition App developed by Nuance Communications ...

Groupon
Software; Phone apps

Redeem Groupon deals (as much as 50-90% off!) on everything ...

Accessibility
Software; Graphic design software

Accessibility refers to the goal of providing content and ...

Snap Assist
Software; Operating systems

A new Snap Assist feature also helps users work out which ...

Creator

Featured blossaries

Richest Women in the U.S

Category: Business   1 4 Terms

The World of Moroccan Cuisine

Category: Food   4 9 Terms

Indonesian Food

Category: Food   2 11 Terms

Wars

Category: History   1 1 Terms

MMO Gamer

Category: Entertainment   1 20 Terms

War

Category: History   3 21 Terms

TermWiki is ranked top innovative application by IDC.

© 2025 CSOFT International, Ltd.   

Follow us on: